Dataset statistics
| Number of variables | 23 |
|---|---|
| Number of observations | 1929935 |
| Missing cells | 115638 |
| Missing cells (%) | 0.3% |
| Duplicate rows | 183366 |
| Duplicate rows (%) | 9.5% |
| Total size in memory | 353.4 MiB |
| Average record size in memory | 192.0 B |
Variable types
| Unsupported | 1 |
|---|---|
| Numeric | 15 |
| Boolean | 7 |
| Dataset has 183366 (9.5%) duplicate rows | Duplicates |
potential_issue is highly imbalanced (99.4%) | Imbalance |
oe_constraint is highly imbalanced (99.8%) | Imbalance |
stop_auto_buy is highly imbalanced (77.4%) | Imbalance |
rev_stop is highly imbalanced (99.5%) | Imbalance |
went_on_backorder is highly imbalanced (93.8%) | Imbalance |
lead_time has 115617 (6.0%) missing values | Missing |
national_inv is highly skewed (γ1 = 340.2206342) | Skewed |
in_transit_qty is highly skewed (γ1 = 168.9800308) | Skewed |
forecast_3_month is highly skewed (γ1 = 142.7827259) | Skewed |
forecast_6_month is highly skewed (γ1 = 138.8179394) | Skewed |
forecast_9_month is highly skewed (γ1 = 142.6836687) | Skewed |
sales_1_month is highly skewed (γ1 = 193.7199727) | Skewed |
sales_3_month is highly skewed (γ1 = 141.8139424) | Skewed |
sales_6_month is highly skewed (γ1 = 138.9269756) | Skewed |
sales_9_month is highly skewed (γ1 = 135.4356641) | Skewed |
min_bank is highly skewed (γ1 = 130.9625785) | Skewed |
pieces_past_due is highly skewed (γ1 = 414.2698848) | Skewed |
local_bo_qty is highly skewed (γ1 = 149.6208797) | Skewed |
sku is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
national_inv has 123076 (6.4%) zeros | Zeros |
in_transit_qty has 1541941 (79.9%) zeros | Zeros |
forecast_3_month has 1347744 (69.8%) zeros | Zeros |
forecast_6_month has 1240252 (64.3%) zeros | Zeros |
forecast_9_month has 1182117 (61.3%) zeros | Zeros |
sales_1_month has 1100061 (57.0%) zeros | Zeros |
sales_3_month has 869086 (45.0%) zeros | Zeros |
sales_6_month has 739645 (38.3%) zeros | Zeros |
sales_9_month has 669802 (34.7%) zeros | Zeros |
min_bank has 997258 (51.7%) zeros | Zeros |
pieces_past_due has 1901631 (98.5%) zeros | Zeros |
perf_6_month_avg has 44675 (2.3%) zeros | Zeros |
perf_12_month_avg has 37885 (2.0%) zeros | Zeros |
local_bo_qty has 1903730 (98.6%) zeros | Zeros |
Reproduction
| Analysis started | 2023-05-09 10:54:24.836197 |
|---|---|
| Analysis finished | 2023-05-09 10:56:38.155147 |
| Duration | 2 minutes and 13.32 seconds |
| Software version | ydata-profiling vv4.1.2 |
| Download configuration | config.json |
sku
Unsupported
REJECTED  UNSUPPORTED 
| Missing | 0 |
|---|---|
| Missing (%) | 0.0% |
| Memory size | 29.4 MiB |
national_inv
Real number (ℝ)
SKEWED  ZEROS 
| Distinct | 15903 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 496.56852 |
| Minimum | -27256 |
|---|---|
| Maximum | 12334404 |
| Zeros | 123076 |
| Zeros (%) | 6.4% |
| Negative | 6654 |
| Negative (%) | 0.3% |
| Memory size | 29.4 MiB |
Quantile statistics
| Minimum | -27256 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 4 |
| median | 15 |
| Q3 | 80 |
| 95-th percentile | 924 |
| Maximum | 12334404 |
| Range | 12361660 |
| Interquartile range (IQR) | 76 |
Descriptive statistics
| Standard deviation | 29573.442 |
|---|---|
| Coefficient of variation (CV) | 59.555612 |
| Kurtosis | 131267.42 |
| Mean | 496.56852 |
| Median Absolute Deviation (MAD) | 13 |
| Skewness | 340.22063 |
| Sum | 9.5834446 × 108 |
| Variance | 8.7458847 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 123407 | 6.4% |
| 0 | 123076 | 6.4% |
| 3 | 103497 | 5.4% |
| 4 | 79724 | 4.1% |
| 5 | 67702 | 3.5% |
| 1 | 67101 | 3.5% |
| 6 | 58162 | 3.0% |
| 7 | 53108 | 2.8% |
| 10 | 52847 | 2.7% |
| 8 | 45940 | 2.4% |
| Other values (15893) | 1155370 |
| Value | Count | Frequency (%) |
| -27256 | 1 | < 0.1% |
| -25414 | 3 | |
| -22154 | 3 | |
| -17698 | 1 | < 0.1% |
| -17669 | 2 | |
| -13491 | 1 | < 0.1% |
| -9925 | 1 | < 0.1% |
| -8230 | 1 | < 0.1% |
| -8170 | 1 | < 0.1% |
| -8130 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 12334404 | 1 | |
| 12324456 | 1 | |
| 12315072 | 1 | |
| 12309096 | 1 | |
| 12285100 | 1 | |
| 12181612 | 1 | |
| 12166440 | 1 | |
| 12145792 | 1 | |
| 6363276 | 1 | |
| 6352932 | 1 |
lead_time
Real number (ℝ)
| Distinct | 32 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 115617 |
| Missing (%) | 6.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.8786266 |
| Minimum | 0 |
|---|---|
| Maximum | 52 |
| Zeros | 12026 |
| Zeros (%) | 0.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 29.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 4 |
| median | 8 |
| Q3 | 9 |
| 95-th percentile | 12 |
| Maximum | 52 |
| Range | 52 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 7.0542125 |
|---|---|
| Coefficient of variation (CV) | 0.89536069 |
| Kurtosis | 26.243386 |
| Mean | 7.8786266 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 4.556573 |
| Sum | 14294334 |
| Variance | 49.761914 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 8 | 780719 | |
| 2 | 384319 | |
| 12 | 228997 | 11.9% |
| 4 | 147045 | 7.6% |
| 9 | 141423 | 7.3% |
| 52 | 34418 | 1.8% |
| 3 | 18602 | 1.0% |
| 10 | 16248 | 0.8% |
| 0 | 12026 | 0.6% |
| 14 | 11820 | 0.6% |
| Other values (22) | 38701 | 2.0% |
| (Missing) | 115617 | 6.0% |
| Value | Count | Frequency (%) |
| 0 | 12026 | 0.6% |
| 1 | 24 | < 0.1% |
| 2 | 384319 | |
| 3 | 18602 | 1.0% |
| 4 | 147045 | 7.6% |
| 5 | 4609 | 0.2% |
| 6 | 5826 | 0.3% |
| 7 | 239 | < 0.1% |
| 8 | 780719 | |
| 9 | 141423 | 7.3% |
| Value | Count | Frequency (%) |
| 52 | 34418 | |
| 40 | 56 | < 0.1% |
| 35 | 40 | < 0.1% |
| 30 | 356 | < 0.1% |
| 28 | 96 | < 0.1% |
| 26 | 120 | < 0.1% |
| 25 | 8 | < 0.1% |
| 24 | 148 | < 0.1% |
| 23 | 16 | < 0.1% |
| 22 | 152 | < 0.1% |
in_transit_qty
Real number (ℝ)
SKEWED  ZEROS 
| Distinct | 5543 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 43.064419 |
| Minimum | 0 |
|---|---|
| Maximum | 489408 |
| Zeros | 1541941 |
| Zeros (%) | 79.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 29.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 66 |
| Maximum | 489408 |
| Range | 489408 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1295.4208 |
|---|---|
| Coefficient of variation (CV) | 30.081001 |
| Kurtosis | 41191.441 |
| Mean | 43.064419 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 168.98003 |
| Sum | 83111487 |
| Variance | 1678115.1 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1541941 | |
| 1 | 41250 | 2.1% |
| 2 | 25128 | 1.3% |
| 3 | 19506 | 1.0% |
| 4 | 17436 | 0.9% |
| 5 | 14608 | 0.8% |
| 6 | 12907 | 0.7% |
| 10 | 10109 | 0.5% |
| 8 | 9932 | 0.5% |
| 7 | 9209 | 0.5% |
| Other values (5533) | 227908 | 11.8% |
| Value | Count | Frequency (%) |
| 0 | 1541941 | |
| 1 | 41250 | 2.1% |
| 2 | 25128 | 1.3% |
| 3 | 19506 | 1.0% |
| 4 | 17436 | 0.9% |
| 5 | 14608 | 0.8% |
| 6 | 12907 | 0.7% |
| 7 | 9209 | 0.5% |
| 8 | 9932 | 0.5% |
| 9 | 7179 | 0.4% |
| Value | Count | Frequency (%) |
| 489408 | 1 | |
| 487680 | 1 | |
| 328060 | 1 | |
| 327156 | 1 | |
| 292093 | 1 | |
| 288960 | 1 | |
| 288768 | 1 | |
| 285365 | 1 | |
| 276703 | 1 | |
| 265272 | 1 |
forecast_3_month
Real number (ℝ)
SKEWED  ZEROS 
| Distinct | 8293 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 178.53996 |
| Minimum | 0 |
|---|---|
| Maximum | 1510592 |
| Zeros | 1347744 |
| Zeros (%) | 69.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 29.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 4 |
| 95-th percentile | 300 |
| Maximum | 1510592 |
| Range | 1510592 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 5108.7715 |
|---|---|
| Coefficient of variation (CV) | 28.614163 |
| Kurtosis | 27297.357 |
| Mean | 178.53996 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 142.78273 |
| Sum | 3.4457033 × 108 |
| Variance | 26099546 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1347744 | |
| 1 | 35757 | 1.9% |
| 2 | 29961 | 1.6% |
| 5 | 22258 | 1.2% |
| 4 | 21158 | 1.1% |
| 3 | 18427 | 1.0% |
| 10 | 16398 | 0.8% |
| 6 | 15417 | 0.8% |
| 20 | 12596 | 0.7% |
| 12 | 12576 | 0.7% |
| Other values (8283) | 397642 | 20.6% |
| Value | Count | Frequency (%) |
| 0 | 1347744 | |
| 1 | 35757 | 1.9% |
| 2 | 29961 | 1.6% |
| 3 | 18427 | 1.0% |
| 4 | 21158 | 1.1% |
| 5 | 22258 | 1.2% |
| 6 | 15417 | 0.8% |
| 7 | 9240 | 0.5% |
| 8 | 11809 | 0.6% |
| 9 | 7790 | 0.4% |
| Value | Count | Frequency (%) |
| 1510592 | 1 | |
| 1427612 | 1 | |
| 1218328 | 2 | |
| 1126656 | 1 | |
| 1103084 | 1 | |
| 1092576 | 1 | |
| 1058396 | 1 | |
| 1046592 | 1 | |
| 1037228 | 1 | |
| 1021940 | 1 |
forecast_6_month
Real number (ℝ)
SKEWED  ZEROS 
| Distinct | 11788 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 345.46607 |
| Minimum | 0 |
|---|---|
| Maximum | 2461360 |
| Zeros | 1240252 |
| Zeros (%) | 64.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 29.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 12 |
| 95-th percentile | 600 |
| Maximum | 2461360 |
| Range | 2461360 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 9831.5646 |
|---|---|
| Coefficient of variation (CV) | 28.458843 |
| Kurtosis | 25080.966 |
| Mean | 345.46607 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 138.81794 |
| Sum | 6.6672672 × 108 |
| Variance | 96659663 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1240252 | |
| 1 | 31809 | 1.6% |
| 2 | 30224 | 1.6% |
| 3 | 22671 | 1.2% |
| 4 | 21347 | 1.1% |
| 5 | 19028 | 1.0% |
| 6 | 18113 | 0.9% |
| 10 | 17975 | 0.9% |
| 8 | 14644 | 0.8% |
| 20 | 13814 | 0.7% |
| Other values (11778) | 500057 |
| Value | Count | Frequency (%) |
| 0 | 1240252 | |
| 1 | 31809 | 1.6% |
| 2 | 30224 | 1.6% |
| 3 | 22671 | 1.2% |
| 4 | 21347 | 1.1% |
| 5 | 19028 | 1.0% |
| 6 | 18113 | 0.9% |
| 7 | 12868 | 0.7% |
| 8 | 14644 | 0.8% |
| 9 | 7656 | 0.4% |
| Value | Count | Frequency (%) |
| 2461360 | 1 | |
| 2446072 | 1 | |
| 2157024 | 1 | |
| 2119148 | 1 | |
| 2109740 | 1 | |
| 2104128 | 1 | |
| 2094452 | 1 | |
| 2094336 | 1 | |
| 2087396 | 1 | |
| 2085044 | 1 |
forecast_9_month
Real number (ℝ)
SKEWED  ZEROS 
| Distinct | 14523 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 506.60701 |
| Minimum | 0 |
|---|---|
| Maximum | 3777304 |
| Zeros | 1182117 |
| Zeros (%) | 61.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 29.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 20 |
| 95-th percentile | 896 |
| Maximum | 3777304 |
| Range | 3777304 |
| Interquartile range (IQR) | 20 |
Descriptive statistics
| Standard deviation | 14345.435 |
|---|---|
| Coefficient of variation (CV) | 28.316692 |
| Kurtosis | 26835.195 |
| Mean | 506.60701 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 142.68367 |
| Sum | 9.777181 × 108 |
| Variance | 2.0579149 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1182117 | |
| 1 | 30475 | 1.6% |
| 2 | 29263 | 1.5% |
| 3 | 23594 | 1.2% |
| 4 | 21986 | 1.1% |
| 5 | 20113 | 1.0% |
| 6 | 18689 | 1.0% |
| 10 | 18365 | 1.0% |
| 8 | 15698 | 0.8% |
| 20 | 14264 | 0.7% |
| Other values (14513) | 555370 |
| Value | Count | Frequency (%) |
| 0 | 1182117 | |
| 1 | 30475 | 1.6% |
| 2 | 29263 | 1.5% |
| 3 | 23594 | 1.2% |
| 4 | 21986 | 1.1% |
| 5 | 20113 | 1.0% |
| 6 | 18689 | 1.0% |
| 7 | 11748 | 0.6% |
| 8 | 15698 | 0.8% |
| 9 | 8974 | 0.5% |
| Value | Count | Frequency (%) |
| 3777304 | 1 | |
| 3760840 | 1 | |
| 3232820 | 1 | |
| 3229292 | 1 | |
| 3206948 | 1 | |
| 3196364 | 1 | |
| 3162260 | 1 | |
| 3158732 | 1 | |
| 3149324 | 1 | |
| 3124704 | 1 |
sales_1_month
Real number (ℝ)
SKEWED  ZEROS 
| Distinct | 6088 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 55.368193 |
| Minimum | 0 |
|---|---|
| Maximum | 741774 |
| Zeros | 1100061 |
| Zeros (%) | 57.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 29.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 4 |
| 95-th percentile | 106 |
| Maximum | 741774 |
| Range | 741774 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 1884.3775 |
|---|---|
| Coefficient of variation (CV) | 34.033574 |
| Kurtosis | 53099.568 |
| Mean | 55.368193 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 193.71997 |
| Sum | 1.0685696 × 108 |
| Variance | 3550878.5 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1100061 | |
| 1 | 165508 | 8.6% |
| 2 | 90068 | 4.7% |
| 3 | 56397 | 2.9% |
| 4 | 43288 | 2.2% |
| 5 | 33820 | 1.8% |
| 6 | 27013 | 1.4% |
| 7 | 21695 | 1.1% |
| 8 | 19426 | 1.0% |
| 10 | 16603 | 0.9% |
| Other values (6078) | 356055 | 18.4% |
| Value | Count | Frequency (%) |
| 0 | 1100061 | |
| 1 | 165508 | 8.6% |
| 2 | 90068 | 4.7% |
| 3 | 56397 | 2.9% |
| 4 | 43288 | 2.2% |
| 5 | 33820 | 1.8% |
| 6 | 27013 | 1.4% |
| 7 | 21695 | 1.1% |
| 8 | 19426 | 1.0% |
| 9 | 15957 | 0.8% |
| Value | Count | Frequency (%) |
| 741774 | 1 | |
| 741762 | 1 | |
| 741750 | 1 | |
| 393665 | 1 | |
| 376025 | 1 | |
| 369425 | 1 | |
| 366191 | 1 | |
| 361803 | 1 | |
| 361239 | 1 | |
| 359505 | 1 |
sales_3_month
Real number (ℝ)
SKEWED  ZEROS 
| Distinct | 11149 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 174.66395 |
| Minimum | 0 |
|---|---|
| Maximum | 1105478 |
| Zeros | 869086 |
| Zeros (%) | 45.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 29.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 15 |
| 95-th percentile | 349 |
| Maximum | 1105478 |
| Range | 1105478 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 5188.8572 |
|---|---|
| Coefficient of variation (CV) | 29.70766 |
| Kurtosis | 24391.249 |
| Mean | 174.66395 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 141.81394 |
| Sum | 3.3708989 × 108 |
| Variance | 26924239 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 869086 | |
| 1 | 156660 | 8.1% |
| 2 | 92910 | 4.8% |
| 3 | 60714 | 3.1% |
| 4 | 47486 | 2.5% |
| 5 | 39014 | 2.0% |
| 6 | 31848 | 1.7% |
| 7 | 26572 | 1.4% |
| 8 | 23870 | 1.2% |
| 10 | 20385 | 1.1% |
| Other values (11139) | 561389 |
| Value | Count | Frequency (%) |
| 0 | 869086 | |
| 1 | 156660 | 8.1% |
| 2 | 92910 | 4.8% |
| 3 | 60714 | 3.1% |
| 4 | 47486 | 2.5% |
| 5 | 39014 | 2.0% |
| 6 | 31848 | 1.7% |
| 7 | 26572 | 1.4% |
| 8 | 23870 | 1.2% |
| 9 | 20120 | 1.0% |
| Value | Count | Frequency (%) |
| 1105478 | 1 | |
| 1104181 | 1 | |
| 1100523 | 1 | |
| 1099852 | 1 | |
| 1094112 | 1 | |
| 1091281 | 1 | |
| 1086554 | 1 | |
| 1084974 | 1 | |
| 1081560 | 1 | |
| 1076623 | 1 |
sales_6_month
Real number (ℝ)
SKEWED  ZEROS 
| Distinct | 15813 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 341.56553 |
| Minimum | 0 |
|---|---|
| Maximum | 2146625 |
| Zeros | 739645 |
| Zeros (%) | 38.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 29.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 2 |
| Q3 | 31 |
| 95-th percentile | 696 |
| Maximum | 2146625 |
| Range | 2146625 |
| Interquartile range (IQR) | 31 |
Descriptive statistics
| Standard deviation | 9585.0329 |
|---|---|
| Coefficient of variation (CV) | 28.062062 |
| Kurtosis | 24221.359 |
| Mean | 341.56553 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 138.92698 |
| Sum | 6.5919892 × 108 |
| Variance | 91872855 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 739645 | |
| 1 | 145503 | 7.5% |
| 2 | 90790 | 4.7% |
| 3 | 60480 | 3.1% |
| 4 | 47719 | 2.5% |
| 5 | 39089 | 2.0% |
| 6 | 32346 | 1.7% |
| 7 | 26582 | 1.4% |
| 8 | 24163 | 1.3% |
| 9 | 21058 | 1.1% |
| Other values (15803) | 702559 |
| Value | Count | Frequency (%) |
| 0 | 739645 | |
| 1 | 145503 | 7.5% |
| 2 | 90790 | 4.7% |
| 3 | 60480 | 3.1% |
| 4 | 47719 | 2.5% |
| 5 | 39089 | 2.0% |
| 6 | 32346 | 1.7% |
| 7 | 26582 | 1.4% |
| 8 | 24163 | 1.3% |
| 9 | 21058 | 1.1% |
| Value | Count | Frequency (%) |
| 2146625 | 1 | |
| 2145715 | 1 | |
| 2133557 | 1 | |
| 2123946 | 1 | |
| 2117803 | 1 | |
| 2113901 | 1 | |
| 2112231 | 1 | |
| 2103389 | 1 | |
| 2098852 | 1 | |
| 2086531 | 1 |
sales_9_month
Real number (ℝ)
SKEWED  ZEROS 
| Distinct | 19581 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 523.57736 |
| Minimum | 0 |
|---|---|
| Maximum | 3205172 |
| Zeros | 669802 |
| Zeros (%) | 34.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 29.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 4 |
| Q3 | 47 |
| 95-th percentile | 1060 |
| Maximum | 3205172 |
| Range | 3205172 |
| Interquartile range (IQR) | 47 |
Descriptive statistics
| Standard deviation | 14733.269 |
|---|---|
| Coefficient of variation (CV) | 28.139623 |
| Kurtosis | 23014.498 |
| Mean | 523.57736 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 135.43566 |
| Sum | 1.0104698 × 109 |
| Variance | 2.1706923 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 669802 | |
| 1 | 137677 | 7.1% |
| 2 | 87472 | 4.5% |
| 3 | 59780 | 3.1% |
| 4 | 47281 | 2.4% |
| 5 | 39393 | 2.0% |
| 6 | 32742 | 1.7% |
| 7 | 26897 | 1.4% |
| 8 | 24198 | 1.3% |
| 9 | 21475 | 1.1% |
| Other values (19571) | 783217 |
| Value | Count | Frequency (%) |
| 0 | 669802 | |
| 1 | 137677 | 7.1% |
| 2 | 87472 | 4.5% |
| 3 | 59780 | 3.1% |
| 4 | 47281 | 2.4% |
| 5 | 39393 | 2.0% |
| 6 | 32742 | 1.7% |
| 7 | 26897 | 1.4% |
| 8 | 24198 | 1.3% |
| 9 | 21475 | 1.1% |
| Value | Count | Frequency (%) |
| 3205172 | 1 | |
| 3204929 | 1 | |
| 3201035 | 1 | |
| 3197338 | 1 | |
| 3195211 | 1 | |
| 3182148 | 1 | |
| 3167394 | 1 | |
| 3163794 | 1 | |
| 3120875 | 1 | |
| 3119450 | 1 |
min_bank
Real number (ℝ)
SKEWED  ZEROS 
| Distinct | 5909 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 52.776393 |
| Minimum | 0 |
|---|---|
| Maximum | 313319 |
| Zeros | 997258 |
| Zeros (%) | 51.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 29.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 3 |
| 95-th percentile | 125 |
| Maximum | 313319 |
| Range | 313319 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 1257.9686 |
|---|---|
| Coefficient of variation (CV) | 23.835819 |
| Kurtosis | 23388.382 |
| Mean | 52.776393 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 130.96258 |
| Sum | 1.0185496 × 108 |
| Variance | 1582485 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 997258 | |
| 1 | 287930 | 14.9% |
| 2 | 129167 | 6.7% |
| 3 | 41408 | 2.1% |
| 4 | 25511 | 1.3% |
| 5 | 18360 | 1.0% |
| 6 | 13865 | 0.7% |
| 7 | 11042 | 0.6% |
| 8 | 9010 | 0.5% |
| 15 | 8422 | 0.4% |
| Other values (5899) | 387961 | 20.1% |
| Value | Count | Frequency (%) |
| 0 | 997258 | |
| 1 | 287930 | 14.9% |
| 2 | 129167 | 6.7% |
| 3 | 41408 | 2.1% |
| 4 | 25511 | 1.3% |
| 5 | 18360 | 1.0% |
| 6 | 13865 | 0.7% |
| 7 | 11042 | 0.6% |
| 8 | 9010 | 0.5% |
| 9 | 7035 | 0.4% |
| Value | Count | Frequency (%) |
| 313319 | 1 | |
| 311423 | 1 | |
| 310427 | 1 | |
| 309667 | 1 | |
| 308055 | 1 | |
| 307627 | 1 | |
| 303713 | 1 | |
| 291059 | 1 | |
| 205786 | 1 | |
| 204803 | 1 |
potential_issue
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 18.4 MiB |
| False | |
|---|---|
| True | 989 |
| (Missing) | 1 |
| Value | Count | Frequency (%) |
| False | 1928945 | |
| True | 989 | 0.1% |
| (Missing) | 1 | < 0.1% |
pieces_past_due
Real number (ℝ)
SKEWED  ZEROS 
| Distinct | 874 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.0161943 |
| Minimum | 0 |
|---|---|
| Maximum | 146496 |
| Zeros | 1901631 |
| Zeros (%) | 98.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 29.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 146496 |
| Range | 146496 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 229.6113 |
|---|---|
| Coefficient of variation (CV) | 113.88352 |
| Kurtosis | 210414.07 |
| Mean | 2.0161943 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 414.26988 |
| Sum | 3891122 |
| Variance | 52721.35 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1901631 | |
| 1 | 4350 | 0.2% |
| 2 | 2406 | 0.1% |
| 4 | 1395 | 0.1% |
| 3 | 1357 | 0.1% |
| 5 | 1184 | 0.1% |
| 6 | 923 | < 0.1% |
| 12 | 855 | < 0.1% |
| 10 | 841 | < 0.1% |
| 8 | 691 | < 0.1% |
| Other values (864) | 14301 | 0.7% |
| Value | Count | Frequency (%) |
| 0 | 1901631 | |
| 1 | 4350 | 0.2% |
| 2 | 2406 | 0.1% |
| 3 | 1357 | 0.1% |
| 4 | 1395 | 0.1% |
| 5 | 1184 | 0.1% |
| 6 | 923 | < 0.1% |
| 7 | 550 | < 0.1% |
| 8 | 691 | < 0.1% |
| 9 | 431 | < 0.1% |
| Value | Count | Frequency (%) |
| 146496 | 1 | |
| 137625 | 1 | |
| 98776 | 1 | |
| 87689 | 1 | |
| 83600 | 1 | |
| 79964 | 1 | |
| 74084 | 1 | |
| 61144 | 1 | |
| 59136 | 1 | |
| 36452 | 1 |
perf_6_month_avg
Real number (ℝ)
| Distinct | 102 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -6.8998218 |
| Minimum | -99 |
|---|---|
| Maximum | 1 |
| Zeros | 44675 |
| Zeros (%) | 2.3% |
| Negative | 148578 |
| Negative (%) | 7.7% |
| Memory size | 29.4 MiB |
Quantile statistics
| Minimum | -99 |
|---|---|
| 5-th percentile | -99 |
| Q1 | 0.63 |
| median | 0.82 |
| Q3 | 0.96 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 100 |
| Interquartile range (IQR) | 0.33 |
Descriptive statistics
| Standard deviation | 26.599803 |
|---|---|
| Coefficient of variation (CV) | -3.8551435 |
| Kurtosis | 8.0712063 |
| Mean | -6.8998218 |
| Median Absolute Deviation (MAD) | 0.15 |
| Skewness | -3.1733535 |
| Sum | -13316201 |
| Variance | 707.54953 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.99 | 163323 | 8.5% |
| 1 | 150339 | 7.8% |
| -99 | 148578 | 7.7% |
| 0.73 | 128818 | 6.7% |
| 0.98 | 97390 | 5.0% |
| 0.97 | 71120 | 3.7% |
| 0.95 | 50482 | 2.6% |
| 0.78 | 49056 | 2.5% |
| 0.82 | 46602 | 2.4% |
| 0 | 44675 | 2.3% |
| Other values (92) | 979551 |
| Value | Count | Frequency (%) |
| -99 | 148578 | |
| 0 | 44675 | 2.3% |
| 0.01 | 648 | < 0.1% |
| 0.02 | 1156 | 0.1% |
| 0.03 | 829 | < 0.1% |
| 0.04 | 724 | < 0.1% |
| 0.05 | 1352 | 0.1% |
| 0.06 | 1393 | 0.1% |
| 0.07 | 2569 | 0.1% |
| 0.08 | 1947 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 150339 | |
| 0.99 | 163323 | |
| 0.98 | 97390 | |
| 0.97 | 71120 | |
| 0.96 | 44116 | 2.3% |
| 0.95 | 50482 | 2.6% |
| 0.94 | 43978 | 2.3% |
| 0.93 | 39878 | 2.1% |
| 0.92 | 25924 | 1.3% |
| 0.91 | 33770 | 1.7% |
perf_12_month_avg
Real number (ℝ)
| Distinct | 102 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -6.462295 |
| Minimum | -99 |
|---|---|
| Maximum | 1 |
| Zeros | 37885 |
| Zeros (%) | 2.0% |
| Negative | 140024 |
| Negative (%) | 7.3% |
| Memory size | 29.4 MiB |
Quantile statistics
| Minimum | -99 |
|---|---|
| 5-th percentile | -99 |
| Q1 | 0.66 |
| median | 0.81 |
| Q3 | 0.95 |
| 95-th percentile | 0.99 |
| Maximum | 1 |
| Range | 100 |
| Interquartile range (IQR) | 0.29 |
Descriptive statistics
| Standard deviation | 25.88335 |
|---|---|
| Coefficient of variation (CV) | -4.0052875 |
| Kurtosis | 8.8594215 |
| Mean | -6.462295 |
| Median Absolute Deviation (MAD) | 0.15 |
| Skewness | -3.2951974 |
| Sum | -12471803 |
| Variance | 669.94779 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.99 | 152682 | 7.9% |
| -99 | 140024 | 7.3% |
| 0.78 | 131353 | 6.8% |
| 0.98 | 106119 | 5.5% |
| 0.97 | 74113 | 3.8% |
| 0.96 | 72752 | 3.8% |
| 0.66 | 61831 | 3.2% |
| 0.9 | 53203 | 2.8% |
| 0.95 | 53112 | 2.8% |
| 1 | 50443 | 2.6% |
| Other values (92) | 1034302 |
| Value | Count | Frequency (%) |
| -99 | 140024 | |
| 0 | 37885 | 2.0% |
| 0.01 | 2814 | 0.1% |
| 0.02 | 437 | < 0.1% |
| 0.03 | 639 | < 0.1% |
| 0.04 | 1179 | 0.1% |
| 0.05 | 743 | < 0.1% |
| 0.06 | 873 | < 0.1% |
| 0.07 | 1193 | 0.1% |
| 0.08 | 1720 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 50443 | 2.6% |
| 0.99 | 152682 | |
| 0.98 | 106119 | |
| 0.97 | 74113 | |
| 0.96 | 72752 | |
| 0.95 | 53112 | 2.8% |
| 0.94 | 43409 | 2.2% |
| 0.93 | 35577 | 1.8% |
| 0.92 | 35805 | 1.9% |
| 0.91 | 34296 | 1.8% |
local_bo_qty
Real number (ℝ)
SKEWED  ZEROS 
| Distinct | 686 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.65370422 |
| Minimum | 0 |
|---|---|
| Maximum | 12530 |
| Zeros | 1903730 |
| Zeros (%) | 98.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 29.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 12530 |
| Range | 12530 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 35.432305 |
|---|---|
| Coefficient of variation (CV) | 54.20235 |
| Kurtosis | 30837.955 |
| Mean | 0.65370422 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 149.62088 |
| Sum | 1261606 |
| Variance | 1255.4482 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1903730 | |
| 1 | 8055 | 0.4% |
| 2 | 3332 | 0.2% |
| 3 | 1930 | 0.1% |
| 4 | 1381 | 0.1% |
| 5 | 1098 | 0.1% |
| 6 | 756 | < 0.1% |
| 7 | 621 | < 0.1% |
| 10 | 566 | < 0.1% |
| 8 | 501 | < 0.1% |
| Other values (676) | 7964 | 0.4% |
| Value | Count | Frequency (%) |
| 0 | 1903730 | |
| 1 | 8055 | 0.4% |
| 2 | 3332 | 0.2% |
| 3 | 1930 | 0.1% |
| 4 | 1381 | 0.1% |
| 5 | 1098 | 0.1% |
| 6 | 756 | < 0.1% |
| 7 | 621 | < 0.1% |
| 8 | 501 | < 0.1% |
| 9 | 382 | < 0.1% |
| Value | Count | Frequency (%) |
| 12530 | 1 | |
| 10045 | 1 | |
| 10024 | 1 | |
| 8600 | 1 | |
| 7812 | 1 | |
| 7048 | 1 | |
| 7000 | 1 | |
| 6965 | 1 | |
| 6955 | 1 | |
| 6732 | 1 |
deck_risk
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 18.4 MiB |
| False | |
|---|---|
| True | |
| (Missing) | 1 |
| Value | Count | Frequency (%) |
| False | 1494481 | |
| True | 435453 | 22.6% |
| (Missing) | 1 | < 0.1% |
oe_constraint
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 18.4 MiB |
| False | |
|---|---|
| True | 292 |
| (Missing) | 1 |
| Value | Count | Frequency (%) |
| False | 1929642 | |
| True | 292 | < 0.1% |
| (Missing) | 1 | < 0.1% |
ppap_risk
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 18.4 MiB |
| False | |
|---|---|
| True | |
| (Missing) | 1 |
| Value | Count | Frequency (%) |
| False | 1697382 | |
| True | 232552 | 12.0% |
| (Missing) | 1 | < 0.1% |
stop_auto_buy
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 18.4 MiB |
| True | |
|---|---|
| False | 70544 |
| (Missing) | 1 |
| Value | Count | Frequency (%) |
| True | 1859390 | |
| False | 70544 | 3.7% |
| (Missing) | 1 | < 0.1% |
rev_stop
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 18.4 MiB |
| False | |
|---|---|
| True | 839 |
| (Missing) | 1 |
| Value | Count | Frequency (%) |
| False | 1929095 | |
| True | 839 | < 0.1% |
| (Missing) | 1 | < 0.1% |
went_on_backorder
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 18.4 MiB |
| False | |
|---|---|
| True | 13981 |
| (Missing) | 1 |
| Value | Count | Frequency (%) |
| False | 1915953 | |
| True | 13981 | 0.7% |
| (Missing) | 1 | < 0.1% |
| sku | national_inv | lead_time | in_transit_qty | forecast_3_month | forecast_6_month | forecast_9_month | sales_1_month | sales_3_month | sales_6_month | sales_9_month | min_bank | potential_issue | pieces_past_due | perf_6_month_avg | perf_12_month_avg | local_bo_qty | deck_risk | oe_constraint | ppap_risk | stop_auto_buy | rev_stop | went_on_backorder | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1026827 | 0.0 | NaN | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | No | 0.0 | -99.00 | -99.00 | 0.0 | No | No | No | Yes | No | No |
| 1 | 1043384 | 2.0 | 9.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | No | 0.0 | 0.99 | 0.99 | 0.0 | No | No | No | Yes | No | No |
| 2 | 1043696 | 2.0 | NaN | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | No | 0.0 | -99.00 | -99.00 | 0.0 | Yes | No | No | Yes | No | No |
| 3 | 1043852 | 7.0 | 8.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | No | 0.0 | 0.10 | 0.13 | 0.0 | No | No | No | Yes | No | No |
| 4 | 1044048 | 8.0 | NaN | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 4.0 | 2.0 | No | 0.0 | -99.00 | -99.00 | 0.0 | Yes | No | No | Yes | No | No |
| 5 | 1044198 | 13.0 | 8.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | No | 0.0 | 0.82 | 0.87 | 0.0 | No | No | No | Yes | No | No |
| 6 | 1044643 | 1095.0 | NaN | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 4.0 | No | 0.0 | -99.00 | -99.00 | 0.0 | Yes | No | No | Yes | No | No |
| 7 | 1045098 | 6.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | No | 0.0 | 0.00 | 0.00 | 0.0 | Yes | No | Yes | Yes | No | No |
| 8 | 1045815 | 140.0 | NaN | 0.0 | 15.0 | 114.0 | 152.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | No | 0.0 | -99.00 | -99.00 | 0.0 | No | No | No | Yes | No | No |
| 9 | 1045867 | 4.0 | 8.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | No | 0.0 | 0.82 | 0.87 | 0.0 | No | No | No | Yes | No | No |
| sku | national_inv | lead_time | in_transit_qty | forecast_3_month | forecast_6_month | forecast_9_month | sales_1_month | sales_3_month | sales_6_month | sales_9_month | min_bank | potential_issue | pieces_past_due | perf_6_month_avg | perf_12_month_avg | local_bo_qty | deck_risk | oe_constraint | ppap_risk | stop_auto_buy | rev_stop | went_on_backorder | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 242065 | 3526982 | 20.0 | 12.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | No | 0.0 | 0.48 | 0.48 | 0.0 | Yes | No | No | Yes | No | No |
| 242066 | 3526983 | 50.0 | 12.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | No | 0.0 | 0.48 | 0.48 | 0.0 | Yes | No | Yes | Yes | No | No |
| 242067 | 3526984 | 20.0 | 12.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | No | 0.0 | 0.48 | 0.48 | 0.0 | Yes | No | No | Yes | No | No |
| 242068 | 3526985 | 165.0 | NaN | 0.0 | 56.0 | 180.0 | 273.0 | 21.0 | 86.0 | 215.0 | 314.0 | 40.0 | No | 0.0 | -99.00 | -99.00 | 0.0 | No | No | No | Yes | No | No |
| 242069 | 3526986 | 11.0 | 12.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | No | 0.0 | 0.48 | 0.48 | 0.0 | Yes | No | No | Yes | No | No |
| 242070 | 3526987 | 12.0 | 12.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | No | 0.0 | 0.48 | 0.48 | 0.0 | Yes | No | No | Yes | No | No |
| 242071 | 3526988 | 13.0 | 12.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | No | 0.0 | 0.48 | 0.48 | 0.0 | Yes | No | No | Yes | No | No |
| 242072 | 3526989 | 13.0 | 12.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | No | 0.0 | 0.48 | 0.48 | 0.0 | Yes | No | No | Yes | No | No |
| 242073 | 3526990 | 10.0 | 12.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | No | 0.0 | 0.48 | 0.48 | 0.0 | Yes | No | No | Yes | No | No |
| 242074 | 3526991 | 2913.0 | 12.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 30.0 | 88.0 | 88.0 | 4.0 | No | 0.0 | 0.48 | 0.48 | 0.0 | Yes | No | No | Yes | No | No |
Most frequently occurring
| national_inv | lead_time | in_transit_qty | forecast_3_month | forecast_6_month | forecast_9_month | sales_1_month | sales_3_month | sales_6_month | sales_9_month | min_bank | potential_issue | pieces_past_due | perf_6_month_avg | perf_12_month_avg | local_bo_qty | deck_risk | oe_constraint | ppap_risk | stop_auto_buy | rev_stop | went_on_backorder | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13440 | 0.0 | NaN | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | No | 0.0 | -99.00 | -99.00 | 0.0 | No | No | No | Yes | No | No | 7893 |
| 99496 | 13.0 | 12.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | No | 0.0 | 0.48 | 0.48 | 0.0 | Yes | No | No | Yes | No | No | 3792 |
| 30231 | 2.0 | 12.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | No | 0.0 | 0.73 | 0.79 | 0.0 | No | No | No | Yes | No | No | 3254 |
| 23603 | 2.0 | 4.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | No | 0.0 | 0.73 | 0.78 | 0.0 | No | No | No | Yes | No | No | 3178 |
| 30251 | 2.0 | 12.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | No | 0.0 | 0.78 | 0.78 | 0.0 | No | No | No | Yes | No | No | 3140 |
| 87337 | 10.0 | 12.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | No | 0.0 | 0.48 | 0.48 | 0.0 | Yes | No | No | Yes | No | No | 3036 |
| 29060 | 2.0 | 9.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | No | 0.0 | 0.70 | 0.66 | 0.0 | No | No | No | Yes | No | No | 2800 |
| 30199 | 2.0 | 12.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | No | 0.0 | 0.57 | 0.68 | 0.0 | No | No | No | Yes | No | No | 2569 |
| 30210 | 2.0 | 12.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | No | 0.0 | 0.63 | 0.72 | 0.0 | No | No | No | Yes | No | No | 2534 |
| 40810 | 3.0 | 12.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | No | 0.0 | 0.57 | 0.68 | 0.0 | No | No | No | Yes | No | No | 2199 |